<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>

<body>
    <table>
        <%
            String options = request.getParameter("specificselection");
            String selectheada=(String)session.getAttribute("selecthead");
            
        Connection db_conn = null;
        Statement statement = null;
        PreparedStatement pstmt;
        ResultSet rs;
            out.println("Deleted"+options+" of "+selectheada+"");
            try{
            Class.forName("com.mysql.jdbc.Driver");
            String url= "jdbc:mysql://localhost:3306/db";
            db_conn = DriverManager.getConnection( url,"root", "root" );
            statement = db_conn.createStatement();
            //rs=statement.executeUpdate(query);
           
            String query="delete from "+selectheada+" where name='"+options+"'";
                
                statement.executeUpdate(query);
                           
 
                
              
                
                db_conn.close();
        } catch(SQLException e){
            e.printStackTrace();
            out.println("sql not found");
            out.println(e);
        } catch(ClassNotFoundException e){
            e.printStackTrace();
            out.println(e);
        }
            %>
        </table>
</body>
